EMT Practice Test

1. Question Content...

---

Question1: Which of the following status values represent a suspect database?

Question2: For a database with its log on a separate device, which of the following dbcc commands show the percentage of free log space? (choose 2)

Question3: A master device failure has occurred which requires the creation of a new master device. Which program must you execute to build it?

Question4: What functionality does Recovery Fault isolation (RFI) provide? (choose 2)

Question5: Automatic recovery uses ________ when comparing the log records to the database

Question6: Which of the following are true about the mount/unmount commands?

Question7: What is the purpose of the row offset table in a DOL index page?

Question8: A particular nonclustered index consists of one index root page, two intermediate index levels and the index leaf level. What is the value of the index level for a leaf page?

Question9: Which statement about allocation pages is FALSE?

Question10: When setting the value for the configuration option "number of open object:, you must condsider which object types? (choose 3)

Question11: Which of the following commands will not delete statistics?

Question12: Which of the following dbcc commands checks for integrity in and between system tables?

Question13: Which of the following can be built by the dataserver utility command? (choose 3)

Question14: A checkpoint command writes ______ to disk.

Question15: Which of the following is NOT an ASE step in the dump transaction process?

Question16: Which of the following is the minimum size for object allocation for ASE 12.5 with a logical page size of 16k?

Question17: What happens to the data and timestamp on a page when a data change is rolled back?

Question18: Which of the following attributes are NOT set using sp_dbcc_updateconfig?

Question19: What is the default for Recovery Fault isolation offline pages?

Question20: All of the following are causes of fragmentation in a table EXCEPT []

Question21: Select name, ((high-low+1)-sum(size)) from sysdevices, sysusages where cstart between low and high and type <>16 group by name The above code displays the :

Question22: Recovery of user databases occurs:

Question23: Overflow pages are used to manage duplicate entries in

Question24: Which SQL statement finds the first page of sysgams:

Question25: What is the maximum rows per page for an APL table on a server configured with an 8K page size?

Question26: Which of the following are true of a DOL Placement Index? (Choose two)

Question27: The main purpose of a checkpoint is to?

Question28: Which of the following statements about the ASE transaction log are TRUE? (Choose three)

Question29: Which of the following statistics is stored in the systatistics table?

Question30: What does an index id of 128 mean?

Question31: Examine the following page header:
PAGE HEADER;
Page header for page 0xcf7a0000
Pageno = 872 nextpg = 872 prevpg = 872
What type of page is this?

Question32: Which of the following commands will not perform a checkpoint on the database?

Question33: When running optdlag, a table shows a very low data page cluster ratio. Which of the following may improve the cluster ratio? (Choose three)

Question34: The DBTABLE structure?(Choose three)

Question35: Given the following data from syslogs, how many user transaction are present?
Xactid op
---------- ---
0xa91400000400 0
0xa91400000400 4
0xa91400000400 30
0xa91400000700 0
0xa91400000700 5
0xa91400000700 30
0xa91400000b00 0
0xa91400000b00 9
0xa91400000b00 9
0xa91400001000 17
0xa91400000b00 30

Question36: Which stored procedure will set Recovery Fault isolation for a database?

Question37: Which of the following is NOT a valid number of cache partitions?

Question38: Which of the following are true of multiple temporary databases (tempdbs)? (choose 2)

Question39: A DBA suspects a leaf-level index pointer does not point to the proper data pages. Which command can be used to verify this?

Question40: Which of the following measure could help improve performance of update statistics?
(Choose three)